--================���Ӽ�¼-------------2015-09-30
--ϵͳ����--
Declare @ParentID int
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAD');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAQ') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAQ', '���̰ѿ�', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAR') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAR', 'ҵ����ѯ', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAS') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAS', '����ȵ���', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAT') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAT', '�������', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAU') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAU', '��ϵά��', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAV') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAV', '��ذ���', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------��ذ���
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAV');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAW') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAW', 'ѡ�¿���', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAY') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAY', '���տ���', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABA') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABA', '�������', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABB') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABB', 'ȡ������', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABC') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABC', '�������', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------���̰ѿ�
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAQ');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABD') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABD', '�Ѷ�δ��', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABF') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABF', '�����', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABG') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABG', '����δѡ', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABH') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABH', '����δѡ', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABI') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABI', '��ѡδ���', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABJ') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABJ', '������', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABK') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABK', '�ѿ�δ��Ƭ', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABL') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABL', '�ѷ�δ�ؼ�', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABM') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABM', '�ѻؼ�δȡ', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------��ϵά��
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAU');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABN') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABN', '��������ף��', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABO') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABO', '����ף��', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end

-------------�������
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAT');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABP') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABP', '����ͻ�����', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABQ') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABQ', '�ﵥ׷��', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------����ȵ���
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAS');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABR') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABR', '�طýӵ�', @ParentID, 'False', 'True', '', 'True', 'False')
	end
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABS') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABS', '�ط�����', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO